StudentEnrollmentPeriodFee 
EntityType  Independent 
Logical Entity Name  StudentEnrollmentPeriodFee 
Default Table Name  AdFees 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

StudentEnrollmentPeriodFee Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
StudentId(FK)    INTEGER  YES 
 
BillingTransactionCodeId    INTEGER  NO 
 
AcademicYearSequence    NUMERIC(3, 0)  NO 
 
FeeDescription    VARCHAR(35)  NO 
 
ModFlag    CHAR(1)  NO 
 
Amount    MONEY(19, 4)  NO 
 
IsOneTimeFee    BIT  NO 
 
LastModifiedUserId    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
StudentEnrollmentPeriodFeeId(PK)    INTEGER  NO 
 
StudentEnrollmentPeriodId(FK)    INTEGER  NO 
 
TermId    INTEGER  YES 
 
IsBilled    BIT  NO 
 
TermSequence    NUMERIC(9, 0)  NO 
 
RevenueUnits    MONEY(19, 4)  YES 
 
Offset    INTEGER  YES 
 
ProgramFeeId    INTEGER  YES 
 
StudentEnrollmentPeriodId(FK)    INTEGER  YES 
 

StudentEnrollmentPeriodFee Keys 
Key Name  Key Type  Keys 
NK_AdFeesBilled  Inversion Entry  IsBilled 
AdFees_adProgramFeeId_N_N_IDX  Inversion Entry  ProgramFeeId 
AdFees_AdEnrollID_Amount_Billed_AdFeesId_AdTermId_U_N_IDX  Alternate Key  StudentEnrollmentPeriodId, Amount, IsBilled, TermId 
AdFees_AdFeesID_U_C_IDX  PrimaryKey  StudentEnrollmentPeriodFeeId 
AdFees_AdEnrollID_AdTermID_SaBillCodeID_AdFeesID_U_N_IDX  Alternate Key  StudentEnrollmentPeriodId, TermId, BillingTransactionCodeId 

StudentEnrollmentPeriodFee Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
StudentEnrollmentPeriod  Non-Identifying  One To Zero or More        StudentEnrollmentPeriodId  NO 
Student  Non-Identifying  Zero or One to Zero or More        StudentId  NO 
StudentEnrollmentPeriod  Non-Identifying  Zero or One to Zero or More        StudentEnrollmentPeriodId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
AutomaticBillingBatchDetail  Non-Identifying  One To Zero or More          NO 
StudentRevenueSummary  Non-Identifying  One To Zero or More          NO 
StudentAccountPendingTransaction  Non-Identifying  One To Zero or More          NO 
StudentAccountTransaction  Non-Identifying  One To Zero or More          NO 
AutomaticBillingBatchDetail  Non-Identifying  One To Zero or More          NO 
StudentAccountPendingTransaction  Non-Identifying  One To Zero or More          NO 
StudentAccountTransaction  Non-Identifying  One To Zero or More          NO 

StudentEnrollmentPeriodFee Check Constraints 
Check Constraint Name  CheckConstraint 

StudentEnrollmentPeriodFee Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StudentEnrollmentPeriodFee 
NO       
Physical (Microsoft SQL Server)
dbo.AdFees 
NO       

StudentEnrollmentPeriodFee Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  LedgerCard_Billing 
Logical  StudentEnrollment 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 

StudentEnrollmentPeriodFee Data Movement Rules 
Name  Type  Rule Text/Value